%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left

    subgraph "Buckets for queries/relations/basics-no-join-if-identical"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: 8, 9, 25, 10<br />2: PgSelect[7]<br />3: PgSelectRows[12]<br />ᐳ: First[11], PgSelectSingle[13]"):::bucket
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 13, 10<br /><br />ROOT PgSelectSingleᐸmessagesᐳ[13]<br />1: <br />ᐳ: 14, 15, 16<br />2: PgSelect[17]<br />3: PgSelectRows[22]<br />ᐳ: First[21], PgSelectSingle[23]"):::bucket
    Bucket2("Bucket 2 (nullableBoundary)<br />Deps: 23, 16<br /><br />ROOT PgSelectSingle{1}ᐸforumsᐳ[23]"):::bucket
    end
    Bucket0 --> Bucket1
    Bucket1 --> Bucket2

    %% plan dependencies
    PgSelect7[["PgSelect[7∈0] ➊<br />ᐸmessagesᐳ<br />More deps:<br />- Object[10]<br />- Constantᐸ'ca70ca70-0000-0000-0000-cec111a0ca70'ᐳ[25]"]]:::plan
    Object10{{"Object[10∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ<br />Dependents: 2"}}:::plan
    Access8{{"Access[8∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access9{{"Access[9∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access8 & Access9 --> Object10
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access8
    __Value2 --> Access9
    First11{{"First[11∈0] ➊"}}:::plan
    PgSelectRows12[["PgSelectRows[12∈0] ➊"]]:::plan
    PgSelectRows12 --> First11
    PgSelect7 --> PgSelectRows12
    PgSelectSingle13{{"PgSelectSingle[13∈0] ➊<br />ᐸmessagesᐳ"}}:::plan
    First11 --> PgSelectSingle13
    PgSelect17[["PgSelect[17∈1] ➊<br />ᐸforumsᐳ<br />More deps:<br />- Object[10]"]]:::plan
    PgClassExpression16{{"PgClassExpression[16∈1] ➊<br />ᐸ__messages__.”forum_id”ᐳ"}}:::plan
    PgClassExpression16 --> PgSelect17
    PgClassExpression14{{"PgClassExpression[14∈1] ➊<br />ᐸ__messages__.”id”ᐳ"}}:::plan
    PgSelectSingle13 --> PgClassExpression14
    PgClassExpression15{{"PgClassExpression[15∈1] ➊<br />ᐸ__messages__.”body”ᐳ"}}:::plan
    PgClassExpression14 o--o PgClassExpression15
    PgSelectSingle13 --> PgClassExpression16
    First21{{"First[21∈1] ➊"}}:::plan
    PgSelectRows22[["PgSelectRows[22∈1] ➊"]]:::plan
    PgSelectRows22 --> First21
    PgSelect17 --> PgSelectRows22
    PgSelectSingle23{{"PgSelectSingle[23∈1] ➊<br />ᐸforumsᐳ"}}:::plan
    First21 --> PgSelectSingle23

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,PgSelect7,Access8,Access9,Object10,First11,PgSelectRows12,PgSelectSingle13 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1,PgClassExpression14,PgClassExpression15,PgClassExpression16,PgSelect17,First21,PgSelectRows22,PgSelectSingle23 bucket1
    classDef bucket2 stroke:#7f007f
    class Bucket2 bucket2

